package com.example.carefree_server.mapper.m_departmentMapper;

import com.example.carefree_server.entity.Pbactivity;
import org.apache.ibatis.annotations.*;

import java.util.List;


@Mapper
public interface signInFormMapper {
    //设计签到表——使用xml注解实现动态sql
    void tweetadd(Pbactivity pb);

    //查询签到表，即显示签到表所显示的需要填的数据
    @Select("select * from pbactivity where aid = #{aid}")
    Pbactivity selecttweet(Integer aid);

    @Delete("delete from pbactivity where aid = #{aid}")
    void deletetweet(Integer aid);

    //更新签到表——使用xml注解实现动态sql
    void updatetweet(Pbactivity pb);

    @Select("select * from pbactivity")
    List<Pbactivity> alltweet();

    @Select("select * from pbactivity where did = #{did}")
    List<Pbactivity> detweet(String did);
}
